home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
fareclasses.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
996b
|
24 lines
/* RCSVER $Id: fareclasses.sql,v 1.7 1999-12-02 16:55:10-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: fareclasses.sql
* Date: 12/28/1998
* memo: Randy Wood
* Description: Create the fareclasses table. This table contains a
* definition of all fareclasses defined.
* Changes: 05/24/99 RNW: Added is_magnetic field.
************************************************************************* */
CREATE TABLE fareclasses
(
class_num NUMBER(38), /* ID of this class */
descr VARCHAR2(20), /* Description of class */
code VARCHAR2(1), /* Unique code for class */
config_num NUMBER(38)
CONSTRAINT ref_fareclasses REFERENCES configset(num)
ON DELETE CASCADE,
is_magnetic NUMBER(1), /* Is this a mag card? */
CONSTRAINT pk_fareclasses PRIMARY KEY (class_num, config_num),
CONSTRAINT unq_fareclasses1 UNIQUE (code, config_num)
);